Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
OE INVENTORIES (table)
Print
RSS
Modified on 2011/08/27 12:10
by
wikibot
Categorized as
Uncategorized
OE PRODUCT_INFORMATION (table)
OE WAREHOUSES (table)
OE PRODUCT_INFORMATION (table)
OE WAREHOUSES (table)
»
OE INVENTORIES (table)
[X]
»
OE INVENTORIES (table)
wikibot
¶
Table
OE.INVENTORIES
Description
Tracks availability of products by product_it and warehouse_id.
Columns
¶
Column
Data Type
Nullable
Default
Description
PRODUCT_ID
NUMBER(6, 0)
not null
Part of concatenated primary key, references product_information.product_id.
WAREHOUSE_ID
NUMBER(3, 0)
not null
Part of concatenated primary key, references warehouses.warehouse_id.
QUANTITY_ON_HAND
NUMBER(8, 0)
not null
Primary Key
¶
Primary Key
Columns
INVENTORY_IX
WAREHOUSE_ID, PRODUCT_ID
Indexes
¶
Index
Type
Columns
INV_PRODUCT_IX
PRODUCT_ID
Check Constraints
¶
Check Constraint
Expression
Description
INVENTORY_QOH_NN
"QUANTITY_ON_HAND" IS NOT NULL
INVENTORY_WAREHOUSE_ID_NN
"WAREHOUSE_ID" IS NOT NULL
Foreign Keys
¶
Relation
Column
Referenced Column
OE.PRODUCT_INFORMATION
PRODUCT_ID
PRODUCT_ID
OE.WAREHOUSES
WAREHOUSE_ID
WAREHOUSE_ID
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.